SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO


CREATE PROCEDURE [dbo].[PaObtenerTipoConvocatoria] 


@Convocatoria  int,
@TipoConv int output


 AS
SET NOCOUNT ON
SET DATEFORMAT DMY
select @TipoConv = tipoconvocatoria from tb_convocatorias where idconvocatoria=@Convocatoria
RETURN
GO
GRANT EXECUTE ON  [dbo].[PaObtenerTipoConvocatoria] TO [Juntas]
GRANT EXECUTE ON  [dbo].[PaObtenerTipoConvocatoria] TO [SoloVer]
GO
